package cz.kfad.ofrss.db;

public class DbConstants {

    public static final String TABLE_RSS_FEED = "rssfeed";
    public static final String COLUMN_RSS_FEED_ID = "rssfeed_id";
    public static final String COLUMN_RSS_FEED_CHANNEL_ID = "rssfeed_channel_id";
    public static final String COLUMN_RSS_FEED_TEXT = "rssfeed_text";
    public static final String COLUMN_RSS_FEED_TITLE = "rssfeed_title";
    public static final String COLUMN_RSS_FEED_READ = "rssfeed_read";
    public static final String COLUMN_RSS_FEED_URL = "rssfeed_url";
    public static final String COLUMN_RSS_FEED_PUBDATE = "rssfeed_pubdate";
	public static final String COLUMN_RSS_FEED_CONTENT = "rssfeed_content";
	public static final String COLUMN_RSS_FEED_CONTENT_ATTEMPTS = "rssfeed_content_attempts";


    public static final String TABLE_CHANNEL = "channel";
    public static final String COLUMN_CHANNEL_ID = "channel_id";
    public static final String COLUMN_CHANNEL_NAME = "channel_name";
    public static final String COLUMN_CHANNEL_URL = "channel_url";
    public static final String COLUMN_CHANNEL_TOTAL_FEEDS = "channel_total_feeds";
    public static final String COLUMN_CHANNEL_UNREAD_FEEDS = "channel_unread_feeds";
    public static final String COLUMN_CHANNEL_NEWEST_FETCHED = "channel_newest_fetched";

    public static final String TABLE_CATEGORY = "category";
    public static final String COLUMN_CATEGORY_ID = "category_id";
    public static final String COLUMN_CATEGORY_NAME = "category_name";
    public static final String COLUMN_CATEGORY_KEY = "category_key";
    public static final String COLUMN_CATEGORY_TOTAL_FEEDS = "category_total_feeds";
    public static final String COLUMN_CATEGORY_UNREAD_FEEDS = "category_unread_feeds";

    public static final String TABLE_CATEGORY_FEED = "category_feed";
    public static final String COLUMN_CATEGORY_FEED_CATEGORY_ID = "category_feed_category_id";
    public static final String COLUMN_CATEGORY_FEED_FEED_ID = "category_feed_feed_id";
	public static final String DESC = " DESC";
}
